<%@ page language="java" import="java.sql.*,com.microsoft.sqlserver.jdbc.*" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1"  %>
<%

//		String url = "jdbc:sqlserver://localhost\\SQLEXPRESS;databaseName=cse132b;";
		String url = "jdbc:sqlserver://localhost:1433;databaseName=cse132b;";
		try {
			if(session.getAttribute("db_conn") == null){
			
				DriverManager.registerDriver(new SQLServerDriver());
//				Connection conn = DriverManager.getConnection(url,"alex","12345");
				Connection conn = DriverManager.getConnection(url,"jill","3achPunt");
				System.out.println("Connection complete!");
				
				session.setAttribute("db_conn", conn);

			}

		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}


%>